package com.itheima.stock;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.web.bind.annotation.ExceptionHandler;

import java.util.Date;

@Data
@NoArgsConstructor
@Builder
@AllArgsConstructor
@HeadRowHeight(value = 35) // 表头行高
@ContentRowHeight(value = 25) // 内容行高
@ColumnWidth(value = 50) // 列宽
public class updowncount {
    @ExcelProperty(value = {"用户信息","总数"},index = 0)
    private Integer count;

 //excel格式化时间

    //这是excl的包
    @DateTimeFormat("yyyy/MM/dd")
    @ExcelProperty(value = {"用户信息","时间"},index = 2)
    @JsonFormat(pattern = "yyyy/MM/dd")
  //忽略字段  @ExcelIgnore
    private Date time;
}
